CREATE TABLE [GSO].[CreditShellData]
(
[CloseDate] [date] NOT NULL,
[AssetID] [float] NOT NULL,
[IssuerID] [float] NULL,
[EverestAssetID] [float] NULL,
[EverestIssuerID] [float] NULL,
[EverestCreditID] [float] NULL,
[IssuerName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetXrefCUSIP] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetXrefLoanX] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Analyst] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CompanyDescription] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ownership] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RecentEvents] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Latest_FinancialName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Latest_Source] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Latest_EBITDA] [float] NULL,
[Latest_AdjustedEBITDA] [float] NULL,
[Latest_TotalLeverage] [float] NULL,
[Latest_InterestCoverage] [float] NULL,
[Latest_FirstLienDebt] [float] NULL,
[Latest_SeniorSecuredDebt] [float] NULL,
[Latest_SeniorDebt] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Latest_OpcoDebt] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Latest_TotalDebt] [float] NULL,
[Latest_CashInterestExpense] [float] NULL,
[Latest_Revenue] [float] NULL,
[Latest_FirstLienLeverage] [float] NULL,
[Latest_SrSecuredLeverage] [float] NULL,
[Latest_GrossOpcoLeverage] [float] NULL,
[Prior_FinancialName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Prior_Source] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Prior_EBITDA] [float] NULL,
[Prior_AdjustedEBITDA] [float] NULL,
[Prior_TotalLeverage] [float] NULL,
[Prior_InterestCoverage] [float] NULL,
[Prior_FirstLienDebt] [float] NULL,
[Prior_SeniorSecuredDebt] [float] NULL,
[Prior_SeniorDebt] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Prior_OpcoDebt] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Prior_TotalDebt] [float] NULL,
[Prior_CashInterestExpense] [float] NULL,
[Prior_Revenue] [float] NULL,
[Prior_FirstLienLeverage] [float] NULL,
[Prior_SrSecuredLeverage] [float] NULL,
[Prior_GrossOpcoLeverage] [float] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [GSO].[CreditShellData] ADD CONSTRAINT [PK_CreditShellData] PRIMARY KEY CLUSTERED  ([CloseDate], [AssetID]) ON [PRIMARY]
GO
